On the accuracy of statistical procedures in Microsoft Excel 2010
نویسندگان
چکیده
منابع مشابه
On the accuracy of statistical procedures in Microsoft Excel 2007
Excel 2007, like its predecessors, fails a standard set of intermediate-level accuracy tests in three areas: statistical distributions, random number generation, and estimation. Additional errors in specific Excel procedures are discussed.Microsoft’s continuing inability to correctly fix errors is discussed. No statistical procedure in Excel should be used until Microsoft documents that the pro...
متن کاملOn the accuracy of statistical procedures in Microsoft Excel 2003
Some of the problems that rendered Excel 97, Excel 2000 and Excel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel’s new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers....
متن کاملOn the accuracy of statistical distributions in Microsoft Excel 2003
Some of previously indicated errors in Microsoft Excel 97 and Excel XP have been eliminated in Excel 2003. But some others have not been corrected in Excel 2003 and new ones have been found as is shown by numerical examples.
متن کاملThe accuracy of statistical distributions in Microsoft® Excel 2007
We provide an assessment of the statistical distributions in Microsoft r © Excel versions 97 through 2007 along with two competing spreadsheet programs, namely Gnumeric 1.7.11 and OpenOffice.org Calc 2.3.0. We find that the accuracy of various statistical functions in Excel 2007 range from unacceptably bad to acceptable but significantly inferior in comparison to alternative implementations. In...
متن کاملStatistical Forecasting with Microsoft Excel Forecast Models
Current forecasting software can be problematic in its level of integration with Microsoft Excel forecasting models. Standalone forecasting software operates in a batch mode with Excel and is impossible to run interactively without custom programming. Excel forecasting add-ins are designed to work within Excel and can be automated to use with forecasting models, but lack support for damped tren...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Computational Statistics
سال: 2014
ISSN: 0943-4062,1613-9658
DOI: 10.1007/s00180-014-0482-5